Overview

Dataset Statistics

Number of Variables 11
Number of Rows 52416
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 11.0 MB
Average Row Size in Memory 219.5 B
Variable Types
  • Numerical: 9
  • Categorical: 2

Dataset Insights

Unnamed: 0 is uniformly distributed Uniform
Wind Speed is skewed Skewed
general diffuse flows is skewed Skewed
diffuse flows is skewed Skewed
DateTime has a high cardinality: 52416 distinct values High Cardinality
Date_proc has a high cardinality: 52416 distinct values High Cardinality
Date_proc has constant length 19 Constant Length
DateTime has all distinct values Unique
Date_proc has all distinct values Unique

Variables


Unnamed: 0

numerical

Approximate Distinct Count 52416
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 26207.5
Minimum 0
Maximum 52415
Zeros 1
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Unnamed: 0 is uniformly distributed

Quantile Statistics

Minimum 0
5-th Percentile 2620.75
Q1 13103.75
Median 26207.5
Q3 39311.25
95-th Percentile 49794.25
Maximum 52415
Range 52415
IQR 26207.5

Descriptive Statistics

Mean 26207.5
Standard Deviation 15131.3402
Variance 2.2896e+08
Sum 1.3737e+09
Skewness 0
Kurtosis -1.2
Coefficient of Variation 0.5774
  • Unnamed: 0 is not normally distributed (p-value 9.122646544817393e-08)

DateTime

categorical

Approximate Distinct Count 52416
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 4168992

Length

Mean 14.5366
Standard Deviation 0.7995
Median 15
Minimum 13
Maximum 16

Sample

1st row 1/1/2017 0:00
2nd row 1/1/2017 0:10
3rd row 1/1/2017 0:20
4th row 1/1/2017 0:30
5th row 1/1/2017 0:40

Letter

Count 0
Lowercase Letter 0
Space Separator 52416
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 552288

Temperature

numerical

Approximate Distinct Count 3437
Approximate Unique (%) 6.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 18.81
Minimum 3.247
Maximum 40.01
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Temperature is skewed right (γ1 = 0.1967)

Quantile Statistics

Minimum 3.247
5-th Percentile 9.8
Q1 14.41
Median 18.78
Q3 22.89
95-th Percentile 28.39
Maximum 40.01
Range 36.763
IQR 8.48

Descriptive Statistics

Mean 18.81
Standard Deviation 5.8155
Variance 33.8198
Sum 985946.216
Skewness 0.1967
Kurtosis -0.3034
Coefficient of Variation 0.3092
  • Temperature is not normally distributed (p-value 2.2236678445228004e-06)
  • Temperature has 142 outliers

Humidity

numerical

Approximate Distinct Count 4443
Approximate Unique (%) 8.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 68.2595
Minimum 11.34
Maximum 94.8
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Humidity is skewed left (γ1 = -0.6251)

Quantile Statistics

Minimum 11.34
5-th Percentile 39.45
Q1 58.31
Median 69.86
Q3 81.4
95-th Percentile 88.9
Maximum 94.8
Range 83.46
IQR 23.09

Descriptive Statistics

Mean 68.2595
Standard Deviation 15.5512
Variance 241.8391
Sum 3.5779e+06
Skewness -0.6251
Kurtosis -0.122
Coefficient of Variation 0.2278
  • Humidity is not normally distributed (p-value 1.6696268442176752e-05)
  • Humidity has 291 outliers

Wind Speed

numerical

Approximate Distinct Count 548
Approximate Unique (%) 1.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 1.9595
Minimum 0.05
Maximum 6.483
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Wind Speed is skewed right (γ1 = 0.4624)

Quantile Statistics

Minimum 0.05
5-th Percentile 0.069
Q1 0.077
Median 0.086
Q3 4.915
95-th Percentile 4.923
Maximum 6.483
Range 6.433
IQR 4.838

Descriptive Statistics

Mean 1.9595
Standard Deviation 2.3489
Variance 5.5172
Sum 102708.568
Skewness 0.4624
Kurtosis -1.7831
Coefficient of Variation 1.1987
  • Wind Speed is not normally distributed (p-value 8.315119670703365e-20)

general diffuse flows

numerical

Approximate Distinct Count 10504
Approximate Unique (%) 20.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 182.6966
Minimum 0.004
Maximum 1163
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • general diffuse flows is skewed right (γ1 = 1.3069)

Quantile Statistics

Minimum 0.004
5-th Percentile 0.037
Q1 0.062
Median 5.0355
Q3 319.6
95-th Percentile 782
Maximum 1163
Range 1162.996
IQR 319.538

Descriptive Statistics

Mean 182.6966
Standard Deviation 264.401
Variance 69907.8675
Sum 9.5762e+06
Skewness 1.3069
Kurtosis 0.4026
Coefficient of Variation 1.4472
  • general diffuse flows is not normally distributed (p-value 6.3199559274709865e-25)
  • general diffuse flows has 2315 outliers

diffuse flows

numerical

Approximate Distinct Count 10449
Approximate Unique (%) 19.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 75.028
Minimum 0.011
Maximum 936
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • diffuse flows is skewed right (γ1 = 2.4568)

Quantile Statistics

Minimum 0.011
5-th Percentile 0.085
Q1 0.122
Median 4.456
Q3 101
95-th Percentile 331.85
Maximum 936
Range 935.989
IQR 100.878

Descriptive Statistics

Mean 75.028
Standard Deviation 124.2109
Variance 15428.3599
Sum 3.9327e+06
Skewness 2.4568
Kurtosis 7.0021
Coefficient of Variation 1.6555
  • diffuse flows is not normally distributed (p-value 3.616586684249413e-24)
  • diffuse flows has 4571 outliers

Zone 1 Power Consumption

numerical

Approximate Distinct Count 27709
Approximate Unique (%) 52.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 32344.9706
Minimum 13895.6962
Maximum 52204.3951
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Zone 1 Power Consumption is skewed right (γ1 = 0.2289)

Quantile Statistics

Minimum 13895.6962
5-th Percentile 21867.3418
Q1 26310.6687
Median 32265.9203
Q3 37309.0182
95-th Percentile 44712.0582
Maximum 52204.3951
Range 38308.6989
IQR 10998.3495

Descriptive Statistics

Mean 32344.9706
Standard Deviation 7130.5626
Variance 5.0845e+07
Sum 1.6954e+09
Skewness 0.2289
Kurtosis -0.7541
Coefficient of Variation 0.2205
  • Zone 1 Power Consumption is not normally distributed (p-value 1.8346103500855648e-08)

Zone 2 Power Consumption

numerical

Approximate Distinct Count 29621
Approximate Unique (%) 56.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 21042.5091
Minimum 8560.0815
Maximum 37408.8608
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Zone 2 Power Consumption is skewed right (γ1 = 0.3289)

Quantile Statistics

Minimum 8560.0815
5-th Percentile 13284.1463
Q1 16980.766
Median 20823.1684
Q3 24713.7175
95-th Percentile 30387.1369
Maximum 37408.8608
Range 28848.7793
IQR 7732.9515

Descriptive Statistics

Mean 21042.5091
Standard Deviation 5201.4659
Variance 2.7055e+07
Sum 1.103e+09
Skewness 0.3289
Kurtosis -0.4375
Coefficient of Variation 0.2472
  • Zone 2 Power Consumption is not normally distributed (p-value 5.19528595891134e-12)
  • Zone 2 Power Consumption has 7 outliers

Zone 3 Power Consumption

numerical

Approximate Distinct Count 22838
Approximate Unique (%) 43.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 838656
Mean 17835.4062
Minimum 5935.1741
Maximum 47598.3264
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Zone 3 Power Consumption is skewed right (γ1 = 1.0238)

Quantile Statistics

Minimum 5935.1741
5-th Percentile 9519.3277
Q1 13129.3266
Median 16415.1175
Q3 21624.1004
95-th Percentile 29905.7087
Maximum 47598.3264
Range 41663.1523
IQR 8494.7738

Descriptive Statistics

Mean 17835.4062
Standard Deviation 6622.1651
Variance 4.3853e+07
Sum 9.3486e+08
Skewness 1.0238
Kurtosis 1.0862
Coefficient of Variation 0.3713
  • Zone 3 Power Consumption has 1191 outliers

Date_proc

categorical

Approximate Distinct Count 52416
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 4402944

Length

Mean 19
Standard Deviation 0
Median 19
Minimum 19
Maximum 19

Sample

1st row 2017-01-01 00:00:0...
2nd row 2017-01-01 00:10:0...
3rd row 2017-01-01 00:20:0...
4th row 2017-01-01 00:30:0...
5th row 2017-01-01 00:40:0...

Letter

Count 0
Lowercase Letter 0
Space Separator 52416
Uppercase Letter 0
Dash Punctuation 104832
Decimal Number 733824
  • Date_proc has words of constant length

Interactions

Correlations

Missing Values